package com.opoc.properties;

import com.opoc.utils.ExcelUtils;

import java.util.LinkedHashMap;
import java.util.Map;

public class ExcelProperties {
  //有顺序要求 不能使用 普通的哈希map
  //for Test
  public static final Map<String, String> PoolHeader = new LinkedHashMap<String, String>(){{
    put("企业编号", ExcelUtils.STRING);
    put("池子编号", ExcelUtils.STRING);
    put("池子名称", ExcelUtils.STRING);
    put("车间名称", ExcelUtils.STRING);
    put("二维码", ExcelUtils.PICTURE);
    put("池子数量", ExcelUtils.INT);
    put("池子容积", ExcelUtils.DOUBLE);
    put("池子尺寸", ExcelUtils.STRING);
    put("池子深度", ExcelUtils.DOUBLE);
    put("池子状态", ExcelUtils.INT);
    put("最大水位", ExcelUtils.DOUBLE);
    put("最低水位", ExcelUtils.DOUBLE);
    put("污水处理流程图", ExcelUtils.PICTURE);
    put("池口位置", ExcelUtils.STRING);
    put("池口数量", ExcelUtils.INT);
    put("池口说明", ExcelUtils.STRING);
    put("池口位置说明", ExcelUtils.STRING);
    put("污水停留时间", ExcelUtils.INT);
    put("池口是否在车间内", ExcelUtils.INT);
    put("是否安装曝气装置", ExcelUtils.INT);
    put("是否曝气", ExcelUtils.INT);
    put("启用时间", ExcelUtils.DATE);
    put("最近清洗时间", ExcelUtils.DATE);
    put("检测时间", ExcelUtils.DATE);
    put("检测公司", ExcelUtils.STRING);
    put("硫化氢(池口)", ExcelUtils.DOUBLE);
    put("硫化氢(池底)", ExcelUtils.DOUBLE);
    put("一氧化碳(池口)", ExcelUtils.DOUBLE);
    put("一氧化碳(池底)", ExcelUtils.DOUBLE);
    put("可燃气体(池口)", ExcelUtils.DOUBLE);
    put("可燃气体(池底)", ExcelUtils.DOUBLE);
  }};
  public static final Map<String, String> PoolHeader_sql = new LinkedHashMap<String, String>(){{
    put("企业编号", "company_id");
    put("池子编号", "pool_id");
    put("池子名称", "pool_name");
    put("车间名称", "workshop_name");
    put("二维码", "pool_code");
    put("池子数量", "pool_num");
    put("池子容积", "pool_volume");
    put("池子尺寸", "pool_size");
    put("池子深度", "pool_depth");
    put("池子状态", "pool_current_state");
    put("最大水位", "pool_max_level");
    put("最低水位", "pool_min_level");
    put("污水处理流程图", "sewage_treatment_flow_chart");
    put("池口位置", "chiko_local");
    put("池口数量", "chiko_count");
    put("池口说明", "chiko_document");
    put("池口位置说明", "chiko_local_document");
    put("污水停留时间", "waste_keep_time");
    put("池口是否在车间内", "if_chiko_in_workshop");
    put("是否安装曝气装置", "if_baoqi_equipment");
    put("是否曝气", "if_baoqi");
    put("启用时间", "start_use_date");
    put("最近清洗时间", "latest_clear_time");
    put("检测时间", "test_date");
    put("检测公司", "test_organization");
    put("硫化氢(池口)", "lhq_top");
    put("硫化氢(池底)", "lhq_bottom");
    put("一氧化碳(池口)", "co_top");
    put("一氧化碳(池底)", "co_bottom");
    put("可燃气体(池口)", "gas_top");
    put("可燃气体(池底)", "gas_bottom");
  }};
  public static final Map<String, String> EnterpriseHeader_sql = new LinkedHashMap<String, String>(){{
    put("企业编号","company_id");
    put("企业名称","company_name");
    put("所属区域","belong_region");
    put("地下池数量","pool_count");
    put("企业联系人","contacts");
    put("联系方式","phone_num");
    put("池子分布图","pool_distribution");
    put("安全管理网络图","security_manage_net");
  }
  };
  public static final Map<String, String> EnterpriseHeader = new LinkedHashMap<String, String>(){
    {
      put("企业编号", ExcelUtils.STRING);
      put("企业名称", ExcelUtils.STRING);
      put("所属区域", ExcelUtils.STRING);
      put("地下池数量", ExcelUtils.INT);
      put("企业联系人", ExcelUtils.STRING);
      put("联系方式", ExcelUtils.STRING);
      put("池子分布图", ExcelUtils.PICTURE);
      put("安全管理网络图", ExcelUtils.PICTURE);
  }};

  }
